package com.jdd.pedicure.dao;

import com.jdd.pedicure.entity.Orders;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import java.util.List;


@Repository
public interface OrderDao extends JpaRepository<Orders,Integer> {

    @Query(nativeQuery = true, value = "SELECT MAX(order_items) item,MAX(staff_name) staff FROM orders")
    String getbest();
}
